Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 922733 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 91.5 MiB |
| Average record size in memory | 104.0 B |
Variable types
| DateTime | 1 |
|---|---|
| Numeric | 12 |
heart_rate is highly correlated with enhanced_speed and 1 other fields | High correlation |
enhanced_speed is highly correlated with heart_rate and 1 other fields | High correlation |
cadence is highly correlated with heart_rate and 1 other fields | High correlation |
slope_steep is highly correlated with slope_ascent | High correlation |
slope_ascent is highly correlated with slope_steep | High correlation |
slope_descent is highly correlated with slope_steep | High correlation |
enhanced_altitude is highly correlated with temp and 1 other fields | High correlation |
temp is highly correlated with enhanced_altitude and 2 other fields | High correlation |
wind_speed is highly correlated with enhanced_altitude and 2 other fields | High correlation |
wind_direct is highly correlated with temp and 1 other fields | High correlation |
timestamp has unique values | Unique |
rain has 527342 (57.2%) zeros | Zeros |
slope_steep has 537702 (58.3%) zeros | Zeros |
slope_ascent has 725108 (78.6%) zeros | Zeros |
slope_descent has 734893 (79.6%) zeros | Zeros |
Reproduction
| Analysis started | 2023-01-17 19:51:42.563050 |
|---|---|
| Analysis finished | 2023-01-17 19:52:54.229734 |
| Duration | 1 minute and 11.67 seconds |
| Software version | pandas-profiling v3.4.0 |
| Download configuration | config.json |
| Distinct | 922733 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.0 MiB |
| Minimum | 2022-01-16 06:53:40 |
|---|---|
| Maximum | 2023-01-16 15:25:45 |
Histogram with fixed size bins (bins=50)
| Distinct | 137 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 143.4291577 |
| Minimum | 58 |
|---|---|
| Maximum | 196 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 58 |
|---|---|
| 5-th percentile | 119 |
| Q1 | 131 |
| median | 139 |
| Q3 | 154 |
| 95-th percentile | 178 |
| Maximum | 196 |
| Range | 138 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 18.23099457 |
|---|---|
| Coefficient of variation (CV) | 0.1271080083 |
| Kurtosis | -0.1126923096 |
| Mean | 143.4291577 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | 0.4606228711 |
| Sum | 132346817 |
| Variance | 332.3691629 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 137 | 30648 | 3.3% |
| 134 | 29830 | 3.2% |
| 136 | 29605 | 3.2% |
| 139 | 28313 | 3.1% |
| 133 | 28178 | 3.1% |
| 138 | 28137 | 3.0% |
| 135 | 27762 | 3.0% |
| 140 | 27727 | 3.0% |
| 131 | 27418 | 3.0% |
| 132 | 26882 | 2.9% |
| Other values (127) | 638233 |
| Value | Count | Frequency (%) |
| 58 | 1 | < 0.1% |
| 60 | 2 | < 0.1% |
| 62 | 3 | < 0.1% |
| 63 | 5 | |
| 64 | 2 | < 0.1% |
| 65 | 5 | |
| 66 | 3 | < 0.1% |
| 67 | 6 | |
| 68 | 8 | |
| 69 | 6 |
| Value | Count | Frequency (%) |
| 196 | 1 | < 0.1% |
| 195 | 3 | < 0.1% |
| 194 | 11 | < 0.1% |
| 193 | 25 | < 0.1% |
| 192 | 90 | < 0.1% |
| 191 | 146 | < 0.1% |
| 190 | 590 | 0.1% |
| 189 | 1048 | |
| 188 | 1518 | |
| 187 | 1249 |
| Distinct | 4601 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.95800197 |
| Minimum | 3.006 |
|---|---|
| Maximum | 37.3536 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 3.006 |
|---|---|
| 5-th percentile | 7.3224 |
| Q1 | 10.4796 |
| median | 11.4228 |
| Q3 | 12.7296 |
| 95-th percentile | 17.9712 |
| Maximum | 37.3536 |
| Range | 34.3476 |
| Interquartile range (IQR) | 2.25 |
Descriptive statistics
| Standard deviation | 3.151807431 |
|---|---|
| Coefficient of variation (CV) | 0.2635730818 |
| Kurtosis | 1.618754781 |
| Mean | 11.95800197 |
| Median Absolute Deviation (MAD) | 1.0728 |
| Skewness | 0.5641809857 |
| Sum | 11034043.03 |
| Variance | 9.933890082 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 11.556 | 9304 | 1.0% |
| 11.1528 | 9156 | 1.0% |
| 11.2536 | 9136 | 1.0% |
| 11.3544 | 8906 | 1.0% |
| 11.4552 | 8885 | 1.0% |
| 11.052 | 8480 | 0.9% |
| 11.6568 | 8376 | 0.9% |
| 10.9512 | 7860 | 0.9% |
| 11.286 | 7842 | 0.8% |
| 11.3868 | 7832 | 0.8% |
| Other values (4591) | 836956 |
| Value | Count | Frequency (%) |
| 3.006 | 4 | < 0.1% |
| 3.0132 | 1 | < 0.1% |
| 3.024 | 143 | |
| 3.0276 | 4 | < 0.1% |
| 3.0312 | 1 | < 0.1% |
| 3.0348 | 4 | < 0.1% |
| 3.0564 | 113 | |
| 3.06 | 3 | < 0.1% |
| 3.0672 | 2 | < 0.1% |
| 3.0708 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 37.3536 | 1 | < 0.1% |
| 33.5916 | 1 | < 0.1% |
| 30.8376 | 1 | < 0.1% |
| 30.6 | 4 | |
| 30.2328 | 1 | < 0.1% |
| 30.1968 | 2 | |
| 30.1644 | 2 | |
| 30.132 | 1 | < 0.1% |
| 30.0312 | 1 | < 0.1% |
| 29.7288 | 2 |
distance
Real number (ℝ≥0)
| Distinct | 706817 |
|---|---|
| Distinct (%) | 76.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7163.378849 |
| Minimum | 0 |
|---|---|
| Maximum | 26408.58 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 543.606 |
| Q1 | 2891.13 |
| median | 6304.52 |
| Q3 | 10460.55 |
| 95-th percentile | 17046.194 |
| Maximum | 26408.58 |
| Range | 26408.58 |
| Interquartile range (IQR) | 7569.42 |
Descriptive statistics
| Standard deviation | 5161.984783 |
|---|---|
| Coefficient of variation (CV) | 0.7206075362 |
| Kurtosis | -0.08478775201 |
| Mean | 7163.378849 |
| Median Absolute Deviation (MAD) | 3698.63 |
| Skewness | 0.7228941544 |
| Sum | 6609886056 |
| Variance | 26646086.91 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3616.46 | 8 | < 0.1% |
| 8804.99 | 7 | < 0.1% |
| 62.69 | 7 | < 0.1% |
| 305.18 | 7 | < 0.1% |
| 797.42 | 7 | < 0.1% |
| 1926.26 | 7 | < 0.1% |
| 6706.09 | 7 | < 0.1% |
| 1472.7 | 7 | < 0.1% |
| 567.91 | 7 | < 0.1% |
| 2343.84 | 6 | < 0.1% |
| Other values (706807) | 922663 |
| Value | Count | Frequency (%) |
| 0 | 2 | |
| 0.49 | 1 | |
| 0.51 | 1 | |
| 0.67 | 1 | |
| 0.87 | 1 | |
| 0.94 | 1 | |
| 1.08 | 2 | |
| 1.15 | 1 | |
| 1.19 | 1 | |
| 1.25 | 1 |
| Value | Count | Frequency (%) |
| 26408.58 | 1 | |
| 26402.76 | 1 | |
| 26389.24 | 1 | |
| 26371.51 | 1 | |
| 26363.73 | 1 | |
| 26361.95 | 1 | |
| 26360.59 | 2 | |
| 26353.62 | 1 | |
| 26348.24 | 1 | |
| 26347.24 | 1 |
| Distinct | 8278 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 315.5884289 |
| Minimum | 129.4 |
|---|---|
| Maximum | 2438.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 129.4 |
|---|---|
| 5-th percentile | 187.8 |
| Q1 | 197.4 |
| median | 242.2 |
| Q3 | 380 |
| 95-th percentile | 617.8 |
| Maximum | 2438.2 |
| Range | 2308.8 |
| Interquartile range (IQR) | 182.6 |
Descriptive statistics
| Standard deviation | 212.1510517 |
|---|---|
| Coefficient of variation (CV) | 0.6722396396 |
| Kurtosis | 20.19028679 |
| Mean | 315.5884289 |
| Median Absolute Deviation (MAD) | 48.6 |
| Skewness | 3.908724197 |
| Sum | 291203857.8 |
| Variance | 45008.06875 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 376.6 | 17401 | 1.9% |
| 197.2 | 6639 | 0.7% |
| 197.6 | 6506 | 0.7% |
| 197.4 | 6169 | 0.7% |
| 196.8 | 5824 | 0.6% |
| 197.8 | 5698 | 0.6% |
| 198 | 5691 | 0.6% |
| 197 | 5595 | 0.6% |
| 196.6 | 5552 | 0.6% |
| 198.6 | 5419 | 0.6% |
| Other values (8268) | 852239 |
| Value | Count | Frequency (%) |
| 129.4 | 5 | < 0.1% |
| 129.6 | 1 | < 0.1% |
| 129.8 | 9 | < 0.1% |
| 130 | 26 | |
| 130.2 | 20 | < 0.1% |
| 130.4 | 14 | < 0.1% |
| 130.6 | 14 | < 0.1% |
| 130.8 | 14 | < 0.1% |
| 131 | 51 | |
| 131.2 | 26 |
| Value | Count | Frequency (%) |
| 2438.2 | 1 | |
| 2438 | 1 | |
| 2437.4 | 1 | |
| 2433.4 | 1 | |
| 2432.8 | 1 | |
| 2431 | 1 | |
| 2430.6 | 1 | |
| 2429.8 | 1 | |
| 2429.2 | 1 | |
| 2428.2 | 1 |
| Distinct | 97 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 85.79426335 |
| Minimum | 31 |
|---|---|
| Maximum | 128 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 31 |
|---|---|
| 5-th percentile | 81 |
| Q1 | 85 |
| median | 86 |
| Q3 | 88 |
| 95-th percentile | 93 |
| Maximum | 128 |
| Range | 97 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 6.989776517 |
|---|---|
| Coefficient of variation (CV) | 0.08147137401 |
| Kurtosis | 15.48179407 |
| Mean | 85.79426335 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -3.404833143 |
| Sum | 79165198 |
| Variance | 48.85697576 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 86 | 171552 | |
| 87 | 148312 | |
| 85 | 129400 | |
| 84 | 82883 | |
| 88 | 75997 | |
| 91 | 49041 | 5.3% |
| 90 | 41090 | 4.5% |
| 83 | 39877 | 4.3% |
| 89 | 39126 | 4.2% |
| 92 | 29322 | 3.2% |
| Other values (87) | 116133 |
| Value | Count | Frequency (%) |
| 31 | 5 | < 0.1% |
| 32 | 11 | < 0.1% |
| 33 | 14 | < 0.1% |
| 34 | 12 | < 0.1% |
| 35 | 21 | < 0.1% |
| 36 | 22 | < 0.1% |
| 37 | 31 | < 0.1% |
| 38 | 37 | |
| 39 | 74 | |
| 40 | 83 |
| Value | Count | Frequency (%) |
| 128 | 2 | < 0.1% |
| 126 | 1 | < 0.1% |
| 125 | 5 | < 0.1% |
| 124 | 4 | < 0.1% |
| 123 | 2 | < 0.1% |
| 122 | 5 | < 0.1% |
| 121 | 6 | < 0.1% |
| 120 | 20 | |
| 119 | 9 | |
| 118 | 22 |
| Distinct | 182 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.98952579 |
| Minimum | 0 |
|---|---|
| Maximum | 29.7 |
| Zeros | 1258 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.5 |
| Q1 | 6.8 |
| median | 13.1 |
| Q3 | 18.9 |
| 95-th percentile | 24.3 |
| Maximum | 29.7 |
| Range | 29.7 |
| Interquartile range (IQR) | 12.1 |
Descriptive statistics
| Standard deviation | 7.258684467 |
|---|---|
| Coefficient of variation (CV) | 0.5588105821 |
| Kurtosis | -1.111004352 |
| Mean | 12.98952579 |
| Median Absolute Deviation (MAD) | 6.1 |
| Skewness | 0.009899828831 |
| Sum | 11985864.1 |
| Variance | 52.68850019 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 19.2 | 22629 | 2.5% |
| 3.8 | 20305 | 2.2% |
| 17.2 | 18019 | 2.0% |
| 10.3 | 16242 | 1.8% |
| 18.2 | 16028 | 1.7% |
| 3.6 | 15937 | 1.7% |
| 5.2 | 15731 | 1.7% |
| 9.6 | 15426 | 1.7% |
| 18.5 | 15081 | 1.6% |
| 1.3 | 14631 | 1.6% |
| Other values (172) | 752704 |
| Value | Count | Frequency (%) |
| 0 | 1258 | 0.1% |
| 0.2 | 2936 | 0.3% |
| 0.3 | 6366 | |
| 0.5 | 2805 | 0.3% |
| 0.6 | 1374 | 0.1% |
| 0.7 | 6056 | |
| 0.8 | 1772 | 0.2% |
| 0.9 | 1508 | 0.2% |
| 1.2 | 3734 | 0.4% |
| 1.3 | 14631 |
| Value | Count | Frequency (%) |
| 29.7 | 1325 | 0.1% |
| 27.4 | 5364 | |
| 27.2 | 5253 | |
| 26.7 | 4507 | |
| 26.5 | 5504 | |
| 26.2 | 3735 | |
| 25.2 | 3284 | 0.4% |
| 24.7 | 8212 | |
| 24.6 | 4981 | |
| 24.3 | 7246 |
| Distinct | 113 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.393785093 |
| Minimum | 0 |
|---|---|
| Maximum | 28.1 |
| Zeros | 6855 |
| Zeros (%) | 0.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4.2 |
| Q1 | 5.7 |
| median | 7.2 |
| Q3 | 10 |
| 95-th percentile | 16.1 |
| Maximum | 28.1 |
| Range | 28.1 |
| Interquartile range (IQR) | 4.3 |
Descriptive statistics
| Standard deviation | 4.03346618 |
|---|---|
| Coefficient of variation (CV) | 0.480530075 |
| Kurtosis | 3.870775129 |
| Mean | 8.393785093 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 1.651445675 |
| Sum | 7745222.5 |
| Variance | 16.26884943 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 6.5 | 37221 | 4.0% |
| 9.7 | 33247 | 3.6% |
| 5 | 28875 | 3.1% |
| 5.8 | 27412 | 3.0% |
| 6.8 | 23439 | 2.5% |
| 4.8 | 22484 | 2.4% |
| 9 | 21734 | 2.4% |
| 5.2 | 21669 | 2.3% |
| 6.2 | 21202 | 2.3% |
| 6.6 | 17775 | 1.9% |
| Other values (103) | 667675 |
| Value | Count | Frequency (%) |
| 0 | 6855 | |
| 3.2 | 3244 | 0.4% |
| 3.7 | 7041 | |
| 3.8 | 6102 | |
| 3.9 | 13450 | |
| 4 | 2584 | 0.3% |
| 4.1 | 6312 | |
| 4.2 | 2196 | 0.2% |
| 4.3 | 12505 | |
| 4.4 | 5870 |
| Value | Count | Frequency (%) |
| 28.1 | 1608 | 0.2% |
| 27.8 | 1273 | 0.1% |
| 26.3 | 1566 | 0.2% |
| 25.6 | 1032 | 0.1% |
| 25.5 | 1276 | 0.1% |
| 24.4 | 3129 | |
| 23.3 | 3901 | |
| 21.8 | 1083 | 0.1% |
| 21.1 | 1125 | 0.1% |
| 19.7 | 5126 |
| Distinct | 197 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 198.5998192 |
| Minimum | 0 |
|---|---|
| Maximum | 359 |
| Zeros | 7686 |
| Zeros (%) | 0.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 27 |
| Q1 | 112 |
| median | 211 |
| Q3 | 278 |
| 95-th percentile | 343 |
| Maximum | 359 |
| Range | 359 |
| Interquartile range (IQR) | 166 |
Descriptive statistics
| Standard deviation | 99.8959487 |
|---|---|
| Coefficient of variation (CV) | 0.5030012066 |
| Kurtosis | -0.9810755758 |
| Mean | 198.5998192 |
| Median Absolute Deviation (MAD) | 78 |
| Skewness | -0.3227512095 |
| Sum | 183254607 |
| Variance | 9979.200567 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 83 | 19854 | 2.2% |
| 278 | 16226 | 1.8% |
| 298 | 15015 | 1.6% |
| 200 | 14406 | 1.6% |
| 246 | 14302 | 1.5% |
| 343 | 13187 | 1.4% |
| 150 | 13106 | 1.4% |
| 201 | 12854 | 1.4% |
| 268 | 12696 | 1.4% |
| 282 | 11690 | 1.3% |
| Other values (187) | 779397 |
| Value | Count | Frequency (%) |
| 0 | 7686 | |
| 1 | 8178 | |
| 3 | 3244 | 0.4% |
| 5 | 1204 | 0.1% |
| 7 | 4981 | |
| 9 | 5223 | |
| 10 | 4719 | |
| 12 | 2268 | 0.2% |
| 13 | 1282 | 0.1% |
| 17 | 5242 |
| Value | Count | Frequency (%) |
| 359 | 4147 | |
| 358 | 6881 | |
| 357 | 1571 | 0.2% |
| 355 | 4271 | |
| 354 | 1644 | 0.2% |
| 353 | 1663 | 0.2% |
| 352 | 4404 | |
| 351 | 1864 | 0.2% |
| 350 | 7775 | |
| 349 | 809 | 0.1% |
| Distinct | 70 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.351917185 |
| Minimum | 0 |
|---|---|
| Maximum | 84.6 |
| Zeros | 527342 |
| Zeros (%) | 57.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1.4 |
| 95-th percentile | 10.9 |
| Maximum | 84.6 |
| Range | 84.6 |
| Interquartile range (IQR) | 1.4 |
Descriptive statistics
| Standard deviation | 7.554861439 |
|---|---|
| Coefficient of variation (CV) | 3.212214055 |
| Kurtosis | 77.83837016 |
| Mean | 2.351917185 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.842994869 |
| Sum | 2170191.6 |
| Variance | 57.07593137 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 527342 | |
| 0.5 | 26574 | 2.9% |
| 0.3 | 24959 | 2.7% |
| 0.1 | 19688 | 2.1% |
| 3.3 | 16692 | 1.8% |
| 0.8 | 16221 | 1.8% |
| 1.1 | 14007 | 1.5% |
| 1 | 13893 | 1.5% |
| 7.6 | 13376 | 1.4% |
| 2.8 | 12951 | 1.4% |
| Other values (60) | 237030 |
| Value | Count | Frequency (%) |
| 0 | 527342 | |
| 0.1 | 19688 | 2.1% |
| 0.2 | 9914 | 1.1% |
| 0.3 | 24959 | 2.7% |
| 0.4 | 10206 | 1.1% |
| 0.5 | 26574 | 2.9% |
| 0.6 | 6553 | 0.7% |
| 0.7 | 1311 | 0.1% |
| 0.8 | 16221 | 1.8% |
| 0.9 | 1537 | 0.2% |
| Value | Count | Frequency (%) |
| 84.6 | 5223 | |
| 24.2 | 3023 | |
| 23.3 | 1337 | 0.1% |
| 22.6 | 4519 | |
| 21.9 | 6401 | |
| 19.3 | 5419 | |
| 18.9 | 3365 | |
| 18.5 | 3198 | |
| 18 | 1523 | 0.2% |
| 16.1 | 1882 | 0.2% |
| Distinct | 60995 |
|---|---|
| Distinct (%) | 6.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.254801703 |
| Minimum | 0 |
|---|---|
| Maximum | 45 |
| Zeros | 537702 |
| Zeros (%) | 58.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 5.970149254 |
| 95-th percentile | 13.15789474 |
| Maximum | 45 |
| Range | 45 |
| Interquartile range (IQR) | 5.970149254 |
Descriptive statistics
| Standard deviation | 5.717967081 |
|---|---|
| Coefficient of variation (CV) | 1.756778939 |
| Kurtosis | 16.34449373 |
| Mean | 3.254801703 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.346409872 |
| Sum | 3003312.94 |
| Variance | 32.69514754 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 537702 | |
| 45 | 3084 | 0.3% |
| 6.666666667 | 1250 | 0.1% |
| 6.153846154 | 1230 | 0.1% |
| 6.472491909 | 949 | 0.1% |
| 6.493506494 | 943 | 0.1% |
| 6.329113924 | 935 | 0.1% |
| 6.309148265 | 910 | 0.1% |
| 6.230529595 | 807 | 0.1% |
| 6.849315068 | 790 | 0.1% |
| Other values (60985) | 374133 |
| Value | Count | Frequency (%) |
| 0 | 537702 | |
| 0.4178854994 | 1 | < 0.1% |
| 0.4866180049 | 1 | < 0.1% |
| 0.6013229104 | 1 | < 0.1% |
| 0.6040471157 | 1 | < 0.1% |
| 0.641025641 | 1 | < 0.1% |
| 0.6715916723 | 1 | < 0.1% |
| 0.6747638327 | 1 | < 0.1% |
| 0.6752194463 | 1 | < 0.1% |
| 0.705716302 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 45 | 3084 | |
| 45 | 1 | < 0.1% |
| 44.98977505 | 1 | < 0.1% |
| 44.94382022 | 2 | < 0.1% |
| 44.94382022 | 2 | < 0.1% |
| 44.94382022 | 6 | < 0.1% |
| 44.94382022 | 1 | < 0.1% |
| 44.94382022 | 2 | < 0.1% |
| 44.94382022 | 1 | < 0.1% |
| 44.94382022 | 1 | < 0.1% |
| Distinct | 71 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.06557129744 |
| Minimum | 0 |
|---|---|
| Maximum | 10 |
| Zeros | 725108 |
| Zeros (%) | 78.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.4 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.170820599 |
|---|---|
| Coefficient of variation (CV) | 2.605112384 |
| Kurtosis | 163.7083376 |
| Mean | 0.06557129744 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.906739497 |
| Sum | 60504.8 |
| Variance | 0.02917967705 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 725108 | |
| 0.2 | 88673 | 9.6% |
| 0.2 | 51557 | 5.6% |
| 0.4 | 21168 | 2.3% |
| 0.4 | 8465 | 0.9% |
| 0.6 | 7232 | 0.8% |
| 0.2 | 3131 | 0.3% |
| 1 | 2953 | 0.3% |
| 0.8 | 2904 | 0.3% |
| 0.6 | 2841 | 0.3% |
| Other values (61) | 8701 | 0.9% |
| Value | Count | Frequency (%) |
| 0 | 725108 | |
| 0.2 | 3131 | 0.3% |
| 0.2 | 51557 | 5.6% |
| 0.2 | 88673 | 9.6% |
| 0.2 | 181 | < 0.1% |
| 0.4 | 84 | < 0.1% |
| 0.4 | 1914 | 0.2% |
| 0.4 | 21168 | 2.3% |
| 0.4 | 8465 | 0.9% |
| 0.6 | 2841 | 0.3% |
| Value | Count | Frequency (%) |
| 10 | 7 | |
| 9.2 | 1 | < 0.1% |
| 8.8 | 1 | < 0.1% |
| 8.4 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 7.4 | 1 | < 0.1% |
| 6.8 | 2 | < 0.1% |
| 6.2 | 1 | < 0.1% |
| 5.6 | 1 | < 0.1% |
| 5.4 | 1 | < 0.1% |
| Distinct | 71 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.06401721842 |
| Minimum | 0 |
|---|---|
| Maximum | 10 |
| Zeros | 734893 |
| Zeros (%) | 79.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.4 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.1710827664 |
|---|---|
| Coefficient of variation (CV) | 2.672449236 |
| Kurtosis | 83.39894901 |
| Mean | 0.06401721842 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.798203909 |
| Sum | 59070.8 |
| Variance | 0.02926931297 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 734893 | |
| 0.2 | 81790 | 8.9% |
| 0.2 | 49297 | 5.3% |
| 0.4 | 20802 | 2.3% |
| 0.4 | 8395 | 0.9% |
| 0.6 | 7163 | 0.8% |
| 0.6 | 3176 | 0.3% |
| 0.8 | 3019 | 0.3% |
| 1 | 3015 | 0.3% |
| 0.2 | 2210 | 0.2% |
| Other values (61) | 8973 | 1.0% |
| Value | Count | Frequency (%) |
| 0 | 734893 | |
| 0.2 | 2210 | 0.2% |
| 0.2 | 49297 | 5.3% |
| 0.2 | 81790 | 8.9% |
| 0.2 | 99 | < 0.1% |
| 0.4 | 66 | < 0.1% |
| 0.4 | 1779 | 0.2% |
| 0.4 | 20802 | 2.3% |
| 0.4 | 8395 | 0.9% |
| 0.6 | 3176 | 0.3% |
| Value | Count | Frequency (%) |
| 10 | 1 | |
| 8.4 | 1 | |
| 7.8 | 1 | |
| 7.6 | 1 | |
| 6.8 | 1 | |
| 6.6 | 1 | |
| 6.4 | 1 | |
| 6.4 | 1 | |
| 6.2 | 1 | |
| 6.2 | 1 |
Auto
The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| timestamp | heart_rate | enhanced_speed | distance | enhanced_altitude | cadence | temp | wind_speed | wind_direct | rain | slope_steep | slope_ascent | slope_descent | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2022-01-16 06:53:40 | 80.0 | 9.1044 | 10.88 | 378.4 | 82.0 | 0.3 | 11.2 | 193.0 | 0.3 | 0.000000 | 0.0 | 0.0 |
| 1 | 2022-01-16 06:53:41 | 83.0 | 9.7092 | 13.57 | 378.2 | 83.0 | 0.3 | 11.2 | 193.0 | 0.3 | 7.434944 | 0.0 | 0.2 |
| 2 | 2022-01-16 06:53:42 | 89.0 | 9.8748 | 16.38 | 378.0 | 83.0 | 0.3 | 11.2 | 193.0 | 0.3 | 7.117438 | 0.0 | 0.2 |
| 3 | 2022-01-16 06:53:44 | 93.0 | 9.4068 | 21.85 | 377.8 | 83.0 | 0.3 | 11.2 | 193.0 | 0.3 | 3.656307 | 0.0 | 0.2 |
| 4 | 2022-01-16 06:53:48 | 96.0 | 9.3708 | 32.38 | 377.6 | 82.0 | 0.3 | 11.2 | 193.0 | 0.3 | 1.899335 | 0.0 | 0.2 |
| 5 | 2022-01-16 06:53:50 | 97.0 | 9.3708 | 37.23 | 377.4 | 82.0 | 0.3 | 11.2 | 193.0 | 0.3 | 4.123711 | 0.0 | 0.2 |
| 6 | 2022-01-16 06:53:51 | 97.0 | 9.3384 | 39.92 | 377.4 | 82.0 | 0.3 | 11.2 | 193.0 | 0.3 | 0.000000 | 0.0 | 0.0 |
| 7 | 2022-01-16 06:53:55 | 99.0 | 9.0684 | 46.59 | 376.2 | 63.0 | 0.3 | 11.2 | 193.0 | 0.3 | 17.991004 | 0.0 | 1.2 |
| 8 | 2022-01-16 06:53:56 | 99.0 | 8.6004 | 48.63 | 375.8 | 77.0 | 0.3 | 11.2 | 193.0 | 0.3 | 19.607843 | 0.0 | 0.4 |
| 9 | 2022-01-16 06:53:58 | 102.0 | 8.0280 | 53.57 | 375.4 | 80.0 | 0.3 | 11.2 | 193.0 | 0.3 | 8.097166 | 0.0 | 0.4 |
Last rows
| timestamp | heart_rate | enhanced_speed | distance | enhanced_altitude | cadence | temp | wind_speed | wind_direct | rain | slope_steep | slope_ascent | slope_descent | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 922723 | 2023-01-16 15:25:12 | 131.0 | 12.1608 | 14904.34 | 269.4 | 88.0 | 3.6 | 15.3 | 158.0 | 0.0 | 5.917160 | 0.2 | 0.0 |
| 922724 | 2023-01-16 15:25:13 | 132.0 | 12.0240 | 14907.68 | 269.8 | 88.0 | 3.6 | 15.3 | 158.0 | 0.0 | 11.976048 | 0.4 | 0.0 |
| 922725 | 2023-01-16 15:25:17 | 134.0 | 12.1248 | 14921.10 | 270.6 | 88.0 | 3.6 | 15.3 | 158.0 | 0.0 | 5.961252 | 0.8 | 0.0 |
| 922726 | 2023-01-16 15:25:19 | 133.0 | 12.0600 | 14927.82 | 271.0 | 87.0 | 3.6 | 15.3 | 158.0 | 0.0 | 5.952381 | 0.4 | 0.0 |
| 922727 | 2023-01-16 15:25:23 | 134.0 | 11.5884 | 14940.93 | 271.8 | 87.0 | 3.6 | 15.3 | 158.0 | 0.0 | 6.102212 | 0.8 | 0.0 |
| 922728 | 2023-01-16 15:25:27 | 135.0 | 11.8584 | 14954.00 | 272.2 | 87.0 | 3.6 | 15.3 | 158.0 | 0.0 | 3.060444 | 0.4 | 0.0 |
| 922729 | 2023-01-16 15:25:32 | 137.0 | 11.5560 | 14970.36 | 272.8 | 87.0 | 3.6 | 15.3 | 158.0 | 0.0 | 3.667482 | 0.6 | 0.0 |
| 922730 | 2023-01-16 15:25:33 | 137.0 | 11.5884 | 14973.58 | 272.8 | 87.0 | 3.6 | 15.3 | 158.0 | 0.0 | 0.000000 | 0.0 | 0.0 |
| 922731 | 2023-01-16 15:25:39 | 139.0 | 12.0924 | 14993.47 | 273.8 | 87.0 | 3.6 | 15.3 | 158.0 | 0.0 | 5.027652 | 1.0 | 0.0 |
| 922732 | 2023-01-16 15:25:45 | 141.0 | 10.0440 | 15011.80 | 274.6 | 79.0 | 3.6 | 15.3 | 158.0 | 0.0 | 4.364430 | 0.8 | 0.0 |